load data
truncate                                       
into table CRST_PO_SYSTEM_PARAMETERS_ALL
fields terminated by "	"                      
trailing nullcols 
( LAST_UPDATE_DATE 		          DATE 'YYYYMMDD HH24:MI:SS',
  last_UPDATED_BY                 ,
  LAST_UPDATE_LOGIN               ,
  CREATION_DATE    		          DATE 'YYYYMMDD HH24:MI:SS',
  CREATED_BY                      ,
  ACCRUED_CODE_COMBINATION_ID     ,
  PRICE_CHANGE_ALLOWANCE          ,
  REQ_CAN_AUTHORIZE               ,
  INSPECTION_REQUIRED_FLAG        ,
  ENFORCE_PRICE_CHANGE_ALLOWANCE  ,
  DEFAULT_RATE_TYPE               ,
  TAXABLE_FLAG                    ,
  USER_DEFINED_RECEIPT_NUM_CODE   ,
  MANUAL_RECEIPT_NUM_TYPE         ,
  USER_DEFINED_QUOTE_NUM_CODE     ,
  MANUAL_QUOTE_NUM_TYPE           ,
  USER_DEFINED_RFQ_NUM_CODE       ,
  MANUAL_RFQ_NUM_TYPE             ,
  USER_DEFINED_PO_NUM_CODE        ,
  MANUAL_PO_NUM_TYPE              ,
  USER_DEFINED_REQ_NUM_CODE       ,
  MANUAL_REQ_NUM_TYPE             ,
  DEFAULT_QUOTE_WARNING_DELAY     ,
  ENFORCE_BUYER_AUTHORITY_FLAG    ,
  ENFORCE_BUYER_NAME_FLAG         ,
  ENFORCE_VENDOR_HOLD_FLAG        ,
  NOTIFY_IF_BLANKET_FLAG          ,
  RFQ_REQUIRED_FLAG               ,
  PO_DOCUMENT_REPORT_ID           ,
  PO_DOCUMENT_PRINT_FLAG          ,
  RFQ_DOCUMENT_REPORT_ID          ,
  RFQ_DOCUMENT_PRINT_FLAG         ,
  LINE_TYPE_ID                    ,
  NEXT_APPROVER_LOOKUP_CODE       ,
  RECEIVING_FLAG                  ,
  ALLOW_ITEM_DESC_UPDATE_FLAG     ,
  DISPOSITION_WARNING_FLAG        ,
  ENFORCE_FULL_LOT_QUANTITIES     ,
  SECURITY_POSITION_STRUCTURE_ID  ,
  MIN_RELEASE_AMOUNT              ,
  PRICE_TYPE_LOOKUP_CODE          ,
  NOTIFICATION_WARNING_DELAY      ,
  PRICE_BREAK_LOOKUP_CODE         ,
  INVOICE_CLOSE_CODE              ,
  RECEIVE_CLOSE_CODE              ,
  INVOICE_CLOSE_TOLERANCE         ,
  RECEIVE_CLOSE_TOLERANCE         ,
  CANCEL_REQS_ON_PO_CANCEL_FLAG   ,
  REQUEST_ID                      ,
  PROGRAM_APPLICATION_ID          ,
  PROGRAM_ID                      ,
  PROGRAM_UPDATE_DATE             DATE 'YYYYMMDD HH24:MI:SS',
  REQIMPORT_GROUP_BY_CODE         ,
  EXPENSE_ACCRUAL_CODE            ,
  INVENTORY_ACCRUAL_CODE          ,
  ORDER_TYPE_ID                   ,
  ORDER_SOURCE_ID                 ,
  SALESREP_ID                     ,
  TERM_ID                         ,
  ORG_ID                          ,
  GLOBAL_ATTRIBUTE1               ,
  GLOBAL_ATTRIBUTE2               ,
  GLOBAL_ATTRIBUTE3               ,
  GLOBAL_ATTRIBUTE4               ,
  GLOBAL_ATTRIBUTE5               ,
  GLOBAL_ATTRIBUTE6               ,
  GLOBAL_ATTRIBUTE7               ,
  GLOBAL_ATTRIBUTE8               ,
  GLOBAL_ATTRIBUTE9               ,
  GLOBAL_ATTRIBUTE10              ,
  GLOBAL_ATTRIBUTE11              ,
  GLOBAL_ATTRIBUTE12              ,
  GLOBAL_ATTRIBUTE13              ,
  GLOBAL_ATTRIBUTE14              ,
  GLOBAL_ATTRIBUTE15              ,
  GLOBAL_ATTRIBUTE16              ,
  GLOBAL_ATTRIBUTE17              ,
  GLOBAL_ATTRIBUTE18              ,
  GLOBAL_ATTRIBUTE19              ,
  GLOBAL_ATTRIBUTE20              ,
  GLOBAL_ATTRIBUTE_CATEGORY       ,
  TAX_FROM_SHIP_TO_LOC_FLAG       ,
  TAX_FROM_ITEM_FLAG              ,
  TAX_FROM_VENDOR_FLAG            ,
  TAX_FROM_VENDOR_SITE_FLAG       ,
  TAX_FROM_SYSTEM_FLAG            ,
  TAX_HIER_SHIP_TO_LOC            ,
  TAX_HIER_ITEM                   ,
  TAX_HIER_VENDOR                 ,
  TAX_HIER_VENDOR_SITE            ,
  TAX_HIER_SYSTEM                 ,
  CREATE_DEBIT_MEMO_FLAG          ,
  ENFORCE_PRICE_CHANGE_AMOUNT     ,
  PRICE_CHANGE_AMOUNT
)
